Budgeting reports
Axiom Budgeting & Performance Reporting 2020.1 comes with a variety of standard budget reports, organized within the following folders and subfolders.
TIP: In some reports, you can drill down to specific data to view how the values were calculated. For more information, see Drilling data: Using Drill Down.
The following reports allow you to view general budget data.
| Report | Description |
|---|---|
| Budget Account Analysis | Use to analyze the proposed budget compared to last year actual, current year budget, and current year projected for an individual account by department. Comments entered into the budget plan files also show on the report to assist with the analysis. |
| Budget FTE Comparison | Use to analyze the proposed budget for FTE compared to last year actual, current year budget, year-to-date actual, and current year projected by department. |
| Budget Key Statistics By Department | Use to view highlighted key statistic trends across multiple fiscal years. |
| Budget Per Unit Analysis | Use to analyze per-unit amounts by comparing the current year projection to next year’s budget for Patient Revenue, Salaries, Supplies, and Other Expenses. |
| Budget Plan Questions | Use to report on inputs from the Plan tab in plan files. |
| Budget Red Flag Analysis | Use to review the comments and explanations for accounts flagged in the budget plan files because they exceeded the defined red-flag threshold. The report shows year-to-date actual and current year projection compared to the proposed budget request. The report also includes fields for the adjustments and comments posted from the budget workbook for each account. |
| Budget Salary Comparison | Use to analyze salary variances for the proposed budget compared to the current year projection. The report also includes prior year and current year actual history to use for comparison. |
| Budget Salary Rate Analysis | Use to analyze departmental average hourly-rate variances in the proposed budget. The report shows prior year and current year actual history and projection compared to the new budget. The variance is broken out into two different categories—FTE and Rate Effect. |
| Budget Summary by Department | Use to analyze total-expense variances by department, comparing the proposed budget to the current-year projection. The report shows prior-year actual, current-year actual, and current-year budget history. |
| Budget Threshold Analysis | Use to analyze account categories by applying a low and high threshold for variances. Historical data for last-year actual and current-year budget are also included. |
| Budget Workbook Changes for CYB and NYB | Use to view highlighted areas where users made inputs in the yellow cells in budget plan files. |
The following reports are designed for budget analysis.
| Report | Description |
|---|---|
| Budget Income Detail | Use to analyze the proposed budget-by-income statement category compared to last-year actual, current-year budget, current-year projected, year-to-date actual, and current-year annualized. Each category shows all values for all accounts in that category. |
| Budget Income Financial Plan | Use to view annuals income statement comparisons across multiple scenarios. |
| Budget Income Scenarios | Use to analyze the proposed budget by FSDetail category compared to the Baseline Budget, NYBScenario1, and NYBScenario2. BudScenario1 and BudScenario2 are fields in the database used to store the results of different sets of driver files. You can use this report to compare passes of the budget (BudPass1, BudPass2). |
| Budget Income Summary | Use to summarize the proposed budget by FSDetail category compared to last-year actual, current-year budget, current-year annualized, and current-year projected. |
| Budget Monthly Dept P&L | Use to review the monthly spread by account for the proposed budget by Budget Type category for an individual department. This report is often used to provide the department manager with a final copy of their month-by-month budget. |
The following reports are designed for budget analysis of new initiatives.
| Report | Description |
|---|---|
| Budget Income Summary-Initiative | Use to review new initiatives by Income Statement category. |
| Budget Income Summary-Initiative Monthly | Use to review new initiatives by Income Statement category by month. |
| Income Statement by Initiative ID | Use to review new initiatives side-by-side for multiple initiatives. |
| Initiative Summary | Use to review new initiatives by department by category, with monthly FTEs. |
The following reports are designed for payroll budget analysis.
| Report | Description |
|---|---|
| FTE Additions and Changes by JobCode | Use to review the FTE summary by department by JobCode, highlighting changes made to the projected year and budget in the plan files. |
| FTEs by Department | Use to review the FTE summary by department, including prior-year actual, current-year budget, and year-to-date actual. The proposed budget is compared to year-to-date actual as well as the current-year budget. |
| FTEs by Department by JobCode | Use to review FTE report by department by job code, including prior-year actual, current-year budget, and year-to-date actual. The proposed budget is compared to year-to-date actual as well as the current-year budget. |
| FTEs by JobCode | Use to review the FTE report by job code, including prior-year actual, current-year budget, and year-to-date actual. The proposed budget is compared to year-to-date actual as well as the current-year budget. |
| Monthly FICA by Department | Use to show monthly total FICA expense by department for both current-year projected and next-year budget. Monthly expense shows for next-year budget. Designed for use by clients who budget FICA in a central department or to review the overall monthly spread of FICA expense. |
| Monthly FTE Target Variance by Department | Use to review a department summary of the FTE variance by month for next year’s budget to the department target. |
| Monthly FTEs by Department | Use to review a department summary of total FTEs by month for next year’s budget. Designed to be used to review the monthly spread of total FTEs as well as by department. |
| NYB Hours and Dollars by Employee | Use to review hours and dollars by employee, job code, paytype, and department. To use this report, the department must use the employee labor option in plan files. |
| Worked Hours Per Unit by Department by JobCode | Use to compare the projected and NY Budget by Provider to the current year by selected DataType. |
Provider Budget Analysis reports (optional feature)
The following reports are designed for physician analysis.
NOTE: You can also find these same reports in the Financial Reporting section > Financial Reporting > Provider Analysis.
| Report | Description |
|---|---|
| Current Period vs Previous Comparison | Use to compare current period vs previous period information by provider as well as last year actual. You can select the data type to analyze in the report. |
| Current Period vs Previous Comparison_CPT | Use to compare current period vs previous period information by CPT or CPT Summary category and last year actual. You can select the data type to analyze in the report. |
| CY Actual vs Budget Comparison | Use to compare current period and year-to-date actual vs budget information by provider and last year actual. You can select the data type to analyze in the report. |
| CY Actual vs Budget Comparison_CPT | Use to compare current period and year-to-date actual vs budget information by CPT or CPT Summary code and last year actual. You can select the data type to analyze in the report. |
| NY Budget Comparison | Use to compare current year projections with next year's budget. |
| NY Budget Comparison_CPT | Use to compare current year projections with next year's budget by CPT or CPT Summary category. |
| Provider Key Indicators By Month | Use to compare month-by-month values for last year, current year, and target by data type. |
| Provider Key Indicators By Month_Rolling 12 | Use to compare month-by-month values for the most recent 12 months by data type. |
| Provider Revenue Per Encounter | Use to compare the current month to the prior three-month average for different years for revenue per encounter. |
| Provider Revenue Per RVU | Use to compare the current month to the prior three-month average for different years for revenue per RVU. |
| Provider Revenue Per WRVU | Use to compare the current month to the prior three-month average for different years for revenue per WRVU. |
| Provider Volume by Specialty | Use to compare actual vs budget volume by data type for the current period and year-to-date, subtotaled by provider specialty. |
| Provider Volume by Specialty_Monthly | Use to show monthly totals by provider, for a chosen data type and year, subtotaled by provider specialty. |
| Provider Compensation Benchmark | Use to compare the proposed budget salary to a salary target for each provider. The target is factored for the budget FTE. |
| Provider Compensation Comparison | Use to compare the calculated budget salary under each of the available compensation methods, by provider, to evaluate the cost of moving providers to another model or standardizing the compensation model. There is also a comparison of the current year vs proposed budget salary cost per work RVU to test if the compensation is changing +\- the Hold Harmless percentage. |
Provider Budget Compensation reports (optional feature)
The following reports are designed for payroll/provider budget analysis.
| Report | Description |
|---|---|
| Provider Compensation Benchmark | Use to compare the proposed budget salary to a salary target for each provider. The target is factored for the budget FTE. |
| Provider Compensation Comparison | Use to compare the calculated budget salary under each of the available compensation methods, by provider, to evaluate the cost of moving providers to another model or standardizing the compensation model. |
